<h1 class="top">Groupfunction</h1>
<h2>The block</h2>
<img src="help/img/groupfunction_avg.png" alt="not block" class="leftFloatIMG">
<p class="leftFloat left">
    The groupfunction block has various functions. You can 
    <a href="#count" class="groupLinks">count</a> colums. Also you get the 
    <a href="#avg" class="groupLinks">average</a>, 
    <a href="#sum" class="groupLinks">sum</a>, 
    <a href="#variance"  class="groupLinks">variance</a>, 
    <a href="#max" class="groupLinks">maximum</a>, 
    <a href="#min" class="groupLinks">minimum</a> and the 
    <a href="#stddev" class="groupLinks">standard deviation</a> of a column. 
    It is used in the 'SELECT'-section. This block chnages the colour to simbolise the <a href="#types" class="groupLinks">types</a>.
</p>
<h2>Functionality</h2>
<h3>Using the Block</h3>
<img src="help/img/groupfunction_avg_plug.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;" >
<p class="text">To use this block you just plug in the green table and colum block and choose your 
    table and paramter. This is shown in the picture on the left. </p>

<h3 id="alias">Setting an alias</h3>
<p class="text">In some functions you have to set an alias. 
    To set the alias, just click in the text field, marked with 'AS' and write it down.  
    The alias is the name under which the result of the function will be shown. You can use it to 
    order or group your results.To use the alias you need the 
    <span class="groupLinks pointer" onclick="fetchthelink('Help/fieldname_get.html','#63a65a');">alias variable</span></p>
<img src="help/img/groupfunction_avg_alias.png" alt="not block" class="img" >
<h2> Functions</h2>
<h3 id="avg">Average</h3>
<img src="help/img/groupfunction_avg.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The average function, calculates the average value of a column. Usually it is used with columns, who hold quantities or money(e.g. a Price).</p>
<h3  id="sum">Summarize</h3>
<img src="help/img/groupfunction_sum.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The summarize function, calculates the summed value of a column. Usually it is used with columns, who hold quantities or money(e.g. a Price).</p>
<h3  id="min">Minimum</h3>
<img src="help/img/groupfunction_min.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The minimum function, returns the minimum value of a column. Usually it is used with columns, who hold quantities or money(e.g. a Price).</p>
<h3 id="max">Maximum</h3>
<img src="help/img/groupfunction_max.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The maximum function, returns the maximum value of a column. Usually it is used with columns, who hold quantities or money(e.g. a Price).</p>
<h3  id="count">Count</h3>
<img src="help/img/groupfunction_count.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The count function counts the rows of a column and return this as number. </p>
<h3  id="variance">Variance </h3>
<img src="help/img/groupfunction_var.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The variance function returns the population standard variance of a column. It considers rows as the whole population, not as a sample, so it has the number of rows as the denominator. </p>
<h3  id="stddev">Standard derivation</h3>
<img src="help/img/groupfunction_stddev.png" alt="not block" class="rightFloatIMG" style="margin-top: 12px;">
<p class="text">The standart derivation function returns the population standard deviation of a column.</p>
<h2 id="types">The types</h2>
<img src="help/img/groupfunction_list.png" alt="Type bool" class="img" style="margin-top: 10px;">
<p class="text"> This colour ,apple green, symbolises list, like all selected columns.</p>
<img src="help/img/groupfunction_int.png" alt="Type numeric" class="img" style="margin-top: 10px;">
<p class="text"> This colour,violet,  symbolises the numeric values of the database</p>
<img src="help/img/groupfunction_text.png" alt="Type text" class="img">
<p class="text"> This colour, brown, symbolises the textual values of the database</p>
<img src="help/img/groupfunction_date.png" alt="Type date" class="img">
<p class="text"> This colour,tapestry, symbolises the date values of the database</p>
<img src="help/img/groupfunction_bool.png" alt="Type bool" class="img">
<p class="text"> This colour ,cyan, symbolises the boolean values of the database</p>
<div id="aliasback"></div>